Release 10.1A: OpenEdge Development:
Progress Dynamics Administration

Specifying gapless sequences

The General Manager provides a generic mechanism for generating reference/sequence numbers for application records without holes in the sequence numbers. Progress sequences cannot be used for this purpose since holes can occur with Progress sequence numbers.

Note: When a sequence number is required during record creation, it should be created at the end of the update as part of the transaction. Such transactions are potential bottlenecks, and locks on the affected table should be kept to an absolute minimum.